" .......too long, Max length is 128"

[Nour]

Hi
When writing a stored procedure,sometimes the line of sql code could be very long and be more than 128 caracthers.
I got an error message saying that the code is vey long and the maximum is 128.
But at the same time, this is erratic in MSSQL server because it works sometimes even with a line of code of more than 800 caracters...
Have you ever experienced the same problem??
What is the solution?
Thanks

[Chris]

If you are using SQL 7 the declare your variables as varchar(2000) or so, this allows them not to preallocate space as does char. Remember that SQL Server has a restriction of 8062 characters per single row of a table.




------------
Nour at 9/22/00 11:48:50 AM


Hi
When writing a stored procedure,sometimes the line of sql code could be very long and be more than 128 caracthers.
I got an error message saying that the code is vey long and the maximum is 128.
But at the same time, this is erratic in MSSQL server because it works sometimes even with a line of code of more than 800 caracters...
Have you ever experienced the same problem??
What is the solution?
Thanks